TG: sql_for_qa/823

SQL для тестировщика

Какое наиболее подходящее решение для выборки имен сотрудников, чья зарплата выше средней зарплаты их собственного отдела?

Anonymous Quiz

Использовать GROUP BY department_id и HAVING salary > AVG(salary).

Применить функцию AVG(salary) OVER (PARTITION BY department_id) в предложении WHERE.

Использовать коррелированный подзапрос в предложении WHERE.

Использовать JOIN с таблицей, содержащей агрегированные средние значения.

Использовать подзапрос с MAX(salary).

246 answered

www.tg-me.com/tw/SQL для тестировщика/com.sql_for_qa/823

1.1K viewsJun 23 at 05:09

tg-me.com/sql_for_qa/823

Create: 2025-06-23
Last Update: 2025-07-01 18:45:06

BY SQL для тестировщика

Warning: Undefined variable $i in /var/www/tg-me/post.php on line 283

Share with your friend now:
tg-me.com/sql_for_qa/823

SQL для тестировщика Telegram | DID YOU KNOW?

Telegram is riding high, adding tens of million of users this year. Now the bill is coming due.Telegram is one of the few significant social-media challengers to Facebook Inc., FB -1.90% on a trajectory toward one billion users active each month by the end of 2022, up from roughly 550 million today.

Start with a fresh view of investing strategy. The combination of risks and fads this quarter looks to be topping. That means the future is ready to move in.Likely, there will not be a wholesale shift. Company actions will aim to benefit from economic growth, inflationary pressures and a return of market-determined interest rates. In turn, all of that should drive the stock market and investment returns higher.